Easy Office 2013 by Rutledge Patrice-Anne & Sherry Gunter

Author:Rutledge, Patrice-Anne & Sherry Gunter
Language: eng
Format: epub
Publisher: Pearson Education
Published: 2013-03-24T16:00:00+00:00

* * *

Copying Formulas Using Fill

Similar to filling a pattern of days or months, Excel can also fill cells with the pattern of a formula. For example, you might want to copy a formula if you have multiple rows or columns that require the same calculation.

Select the cell that has the formula you want to copy.

Position the mouse pointer on the lower-right corner of the beginning cell. The mouse pointer becomes a crosshair.

Press and hold the mouse button, and drag to select the next cells to be filled in.

Release the mouse button. Excel copies the formula to all the selected cells.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.